package com.example.springbootsfzy.mapper;

import com.example.springbootsfzy.domain.Courses;
import com.example.springbootsfzy.domain.CoursewareList;

import java.util.List;

/**
* @author 30658
* @description 针对表【courses】的数据库操作Mapper
* @createDate 2025-01-02 15:11:36
* @Entity com.example.springbootsfzy.domain.Courses
*/

public interface CoursesMapper {

    int deleteByPrimaryKey(Integer id);

    int insert(Courses record);

    int insertSelective(Courses record);

    Courses selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Courses record);

    int updateByPrimaryKey(Courses record);

    List<Courses> selectAll();
    //分页查询
    List<Courses> selectByCoursePage(int pageStar, int pageSize);
    //连表查询所有信息

    List<Courses> selectAllInfo1();

    List<Courses> selectAllInfoPage(int pageStar, int pageSize);

    List<Courses> selectAllInfoPageByCourseId(Integer courseId);

    //通过咨询师id查询课程信息
    List<Courses> selectAllInfoByconsultantId(Integer consultantId);

    //模糊搜索
    List<Courses> selectAllInfoLike(String courseName,Integer consultantId);



}
